package procedure;

public interface DerbySQLProcedureStringsI {

	public static final String LOCAL_CREATE_PROCEDURE_SELECT_ALL_USER_IDS = "CREATE PROCEDURE SELECT_ALL_USER_IDS()"
			+ " PARAMETER STYLE JAVA "
			+ " LANGUAGE JAVA "
			+ " READS SQL DATA "
			+ " DYNAMIC RESULT SETS 2 "
			+ " EXTERNAL NAME 'edu.cs.usask.ca.silver.persistence.datasource.EmbeddedDerbyStorage.selectUserProcedure' ";

	// procedure.RemoteDerbyStorage
	public static final String REMOTE_CREATE_PROCEDURE_SELECT_ALL_USER_IDS = "CREATE PROCEDURE SELECT_ALL_USER_IDS()"
			+ " PARAMETER STYLE JAVA "
			+ " LANGUAGE JAVA "
			+ " READS SQL DATA "
			+ " DYNAMIC RESULT SETS 2 "
			+ " EXTERNAL NAME 'procedure.RemoteDerbyStorage.selectUserProcedure' ";

	public static final String CALL_PROCEDURE_SELECT_ALL_USER_IDS = "{call PROCEDURE SELECT_ALL_USER_IDS()}";

	public static final String DROP_PROCEDURE_SELECT_ALL_USER_IDS = "DROP PROCEDURE SELECT_ALL_USER_IDS";

	public static final String CALL_PROCEDURE_DUPLICATE_SCENARIO = "{CALL DUPLICATE_SCENARIO('%s', '%s' , '%s')}";

	public static final String LOCAL_CREATE_PROCEDURE_DUPLICATE_SCENARIO = "CREATE PROCEDURE DUPLICATE_SCENARIO(DP1 CHAR(36), DP2 CHAR(36), DP3 CHAR(36))"
		+ " PARAMETER STYLE JAVA "
		+ " LANGUAGE JAVA "
		+ " MODIFIES SQL DATA "
		+ " EXTERNAL NAME 'edu.cs.usask.ca.silver.persistence.datasource.EmbeddedDerbyStorage.duplicateScenarioProcedure'";

	public static final String REMOTE_CREATE_PROCEDURE_DUPLICATE_SCENARIO = "CREATE PROCEDURE DUPLICATE_SCENARIO(DP1 CHAR(36), DP2 CHAR(36), DP3 CHAR(36))"
		+ " PARAMETER STYLE JAVA "
		+ " LANGUAGE JAVA "
		+ " MODIFIES SQL DATA "
		+ " EXTERNAL NAME 'procedure.RemoteDerbyStorage.duplicateScenarioProcedure'";

	public static final String DROP_PROCEDURE_DUPLICATE_SCENARIO = "DROP PROCEDURE DUPLICATE_SCENARIO";
	
	public static final String CALL_PROCEDURE_DUPLICATE_SCENARIO_COLLECTION = "{CALL DUPLICATE_SCENARIO_COLLECTION('%s', '%s' , '%s')}";

	public static final String LOCAL_CREATE_PROCEDURE_DUPLICATE_SCENARIO_COLLECTION = "CREATE PROCEDURE DUPLICATE_SCENARIO_COLLECTION(DP1 CHAR(36), DP2 CHAR(36), DP3 CHAR(36))"
		+ " PARAMETER STYLE JAVA "
		+ " LANGUAGE JAVA "
		+ " MODIFIES SQL DATA "
		+ " EXTERNAL NAME 'edu.cs.usask.ca.silver.persistence.datasource.EmbeddedDerbyStorage.duplicateScenarioCollectionProcedure'";
	
	public static final String REMOTE_CREATE_PROCEDURE_DUPLICATE_SCENARIO_COLLECTION = "CREATE PROCEDURE DUPLICATE_SCENARIO_COLLECTION(DP1 CHAR(36), DP2 CHAR(36), DP3 CHAR(36))"
		+ " PARAMETER STYLE JAVA "
		+ " LANGUAGE JAVA "
		+ " MODIFIES SQL DATA "
		+ " EXTERNAL NAME 'procedure.RemoteDerbyStorage.duplicateScenarioCollectionProcedure'";
	
	public static final String DROP_PROCEDURE_DUPLICATE_SCENARIO_COLLECTION = "DROP PROCEDURE DUPLICATE_SCENARIO_COLLECTION";
	
	public static final String CALL_PROCEDURE_DUPLICATE_PARAMETER = "{call DUPLICATE_PARAMETER(%d)}";

	public static final String LOCAL_CREATE_PROCEDURE_DUPLICATE_PARAMETER = "CREATE PROCEDURE DUPLICATE_PARAMETER(DP1 INT)"
			+ " PARAMETER STYLE JAVA "
			+ " LANGUAGE JAVA "
			+ " MODIFIES SQL DATA "
			+ " DYNAMIC RESULT SETS 1"
			+ " EXTERNAL NAME 'edu.cs.usask.ca.silver.persistence.datasource.EmbeddedDerbyStorage.duplicateParameterProcedure' ";

	public static final String REMOTE_CREATE_PROCEDURE_DUPLICATE_PARAMETER = "CREATE PROCEDURE DUPLICATE_PARAMETER(DP1 INT)"
			+ " PARAMETER STYLE JAVA "
			+ " LANGUAGE JAVA "
			+ " MODIFIES SQL DATA "
			+ " DYNAMIC RESULT SETS 1"
			+ " EXTERNAL NAME 'procedure.RemoteDerbyStorage.duplicateParameterProcedure' ";

	public static final String DROP_PROCEDURE_DUPLICATE_PARAMETER = "DROP PROCEDURE DUPLICATE_PARAMETER";

	public static final String CALL_PROCEDURE_DUPLICATE_PARAMETERS_BETWEEN_PS = "{call DUPLICATE_PARAMETERS_BETWEEN_PS(%d, %d)}";

	public static final String LOCAL_CREATE_PROCEDURE_DUPLICATE_PARAMETERS_BETWEEN_PS = "CREATE PROCEDURE DUPLICATE_PARAMETERS_BETWEEN_PS(DP1 INT, DP2 INT)"
			+ " PARAMETER STYLE JAVA "
			+ " LANGUAGE JAVA "
			+ " MODIFIES SQL DATA "
			+ " EXTERNAL NAME 'edu.cs.usask.ca.silver.persistence.datasource.EmbeddedDerbyStorage.duplicateParamameterSetParametersProcedure'";

	public static final String REMOTE_CREATE_PROCEDURE_DUPLICATE_PARAMETERS_BETWEEN_PS = "CREATE PROCEDURE DUPLICATE_PARAMETERS_BETWEEN_PS(DP1 INT, DP2 INT)"
			+ " PARAMETER STYLE JAVA "
			+ " LANGUAGE JAVA "
			+ " MODIFIES SQL DATA "
			+ " EXTERNAL NAME 'procedure.RemoteDerbyStorage.duplicateParamameterSetParametersProcedure'";

	public static final String DROP_PROCEDURE_DUPLICATE_PARAMETERS_BETWEEN_PS = "DROP PROCEDURE DUPLICATE_PARAMETERS_BETWEEN_PS";

	public static final String CALL_PROCEDURE_DUPLICATE_TRAJECTORY_FILES_BETWEEN_SCENARIO = "{call DUPLICATE_TRATECTORY_FILES_BETWEEN_SCENARIO('%s', '%s')}";

	public static final String LOCAL_CREATE_PROCEDURE_DUPLICATE_TRAJECTORY_FILES_BETWEEN_SCENARIO = "CREATE PROCEDURE DUPLICATE_TRATECTORY_FILES_BETWEEN_SCENARIO(DP1 CHAR(36), DP2 CHAR(36))"
			+ " PARAMETER STYLE JAVA "
			+ " LANGUAGE JAVA "
			+ " MODIFIES SQL DATA "
			+ " EXTERNAL NAME 'edu.cs.usask.ca.silver.persistence.datasource.EmbeddedDerbyStorage.duplicateScenarioTrajectoryFilesProcedure'";

	public static final String REMOTE_CREATE_PROCEDURE_DUPLICATE_TRAJECTORY_FILES_BETWEEN_SCENARIO = "CREATE PROCEDURE DUPLICATE_TRATECTORY_FILES_BETWEEN_SCENARIO(DP1 CHAR(36), DP2 CHAR(36))"
			+ " PARAMETER STYLE JAVA "
			+ " LANGUAGE JAVA "
			+ " MODIFIES SQL DATA "
			+ " EXTERNAL NAME 'procedure.RemoteDerbyStorage.duplicateScenarioTrajectoryFilesProcedure'";

	public static final String DROP_PROCEDURE_DUPLICATE_TRAJECTORY_FILES_BETWEEN_SCENARIO = "DROP PROCEDURE DUPLICATE_TRATECTORY_FILES_BETWEEN_SCENARIO";

	public static final String CALL_PROCEDURE_DUPLICATE_ASSOCIATE_FILES_BETWEEN_SCENARIO = "{call DUPLICATE_ASSOCIATE_FILES_BETWEEN_SCENARIO('%s', '%s')}";

	public static final String LOCAL_CREATE_PROCEDURE_DUPLICATE_ASSOCIATE_FILES_BETWEEN_SCENARIO = "CREATE PROCEDURE DUPLICATE_ASSOCIATE_FILES_BETWEEN_SCENARIO(DP1 CHAR(36), DP2 CHAR(36))"
			+ " PARAMETER STYLE JAVA "
			+ " LANGUAGE JAVA "
			+ " MODIFIES SQL DATA "
			+ " EXTERNAL NAME 'edu.cs.usask.ca.silver.persistence.datasource.EmbeddedDerbyStorage.duplicateScenarioAssociateFilesProcedure'";

	public static final String REMOTE_CREATE_PROCEDURE_DUPLICATE_ASSOCIATE_FILES_BETWEEN_SCENARIO = "CREATE PROCEDURE DUPLICATE_ASSOCIATE_FILES_BETWEEN_SCENARIO(DP1 CHAR(36), DP2 CHAR(36))"
			+ " PARAMETER STYLE JAVA "
			+ " LANGUAGE JAVA "
			+ " MODIFIES SQL DATA "
			+ " EXTERNAL NAME 'procedure.RemoteDerbyStorage.duplicateScenarioAssociateFilesProcedure'";

	public static final String DROP_PROCEDURE_DUPLICATE_ASSOCIATE_FILES_BETWEEN_SCENARIO = "DROP PROCEDURE DUPLICATE_ASSOCIATE_FILES_BETWEEN_SCENARIO";

	public static final String CALL_PROCEDURE_DUPLICATE_INPUT_FILES_BETWEEN_SCENARIO = "{call DUPLICATE_INPUT_FILES_BETWEEN_SCENARIO('%s', '%s')}";

	public static final String LOCAL_CREATE_PROCEDURE_DUPLICATE_INPUT_FILES_BETWEEN_SCENARIO = "CREATE PROCEDURE DUPLICATE_INPUT_FILES_BETWEEN_SCENARIO(DP1 CHAR(36), DP2 CHAR(36))"
			+ " PARAMETER STYLE JAVA "
			+ " LANGUAGE JAVA "
			+ " MODIFIES SQL DATA "
			+ " EXTERNAL NAME 'edu.cs.usask.ca.silver.persistence.datasource.EmbeddedDerbyStorage.duplicateScenarioInputFilesProcedure'";

	public static final String REMOTE_CREATE_PROCEDURE_DUPLICATE_INPUT_FILES_BETWEEN_SCENARIO = "CREATE PROCEDURE DUPLICATE_INPUT_FILES_BETWEEN_SCENARIO(DP1 CHAR(36), DP2 CHAR(36))"
			+ " PARAMETER STYLE JAVA "
			+ " LANGUAGE JAVA "
			+ " MODIFIES SQL DATA "
			+ " EXTERNAL NAME 'procedure.RemoteDerbyStorage.duplicateScenarioInputFilesProcedure'";

	public static final String DROP_PROCEDURE_DUPLICATE_INPUT_FILES_BETWEEN_SCENARIO = "DROP PROCEDURE DUPLICATE_INPUT_FILES_BETWEEN_SCENARIO";


	
	public static final String CALL_PROCEDURE_DUPLICATE_ANALYSIS_FILES_BETWEEN_SCENARIO = "{call DUPLICATE_ANALYSIS_FILES_BETWEEN_SCENARIO('%s', '%s')}";

	public static final String LOCAL_CREATE_PROCEDURE_DUPLICATE_ANALYSIS_FILES_BETWEEN_SCENARIO = "CREATE PROCEDURE DUPLICATE_ANALYSIS_FILES_BETWEEN_SCENARIO(DP1 CHAR(36), DP2 CHAR(36))"
			+ " PARAMETER STYLE JAVA "
			+ " LANGUAGE JAVA "
			+ " MODIFIES SQL DATA "
			+ " EXTERNAL NAME 'edu.cs.usask.ca.silver.persistence.datasource.EmbeddedDerbyStorage.duplicateScenarioAnalysisFilesProcedure'";

	public static final String REMOTE_CREATE_PROCEDURE_DUPLICATE_ANALYSIS_FILES_BETWEEN_SCENARIO = "CREATE PROCEDURE DUPLICATE_ANALYSIS_FILES_BETWEEN_SCENARIO(DP1 CHAR(36), DP2 CHAR(36))"
			+ " PARAMETER STYLE JAVA "
			+ " LANGUAGE JAVA "
			+ " MODIFIES SQL DATA "
			+ " EXTERNAL NAME 'procedure.RemoteDerbyStorage.duplicateScenarioAnalysisFilesProcedure'";

	public static final String DROP_PROCEDURE_DUPLICATE_ANALYSIS_FILES_BETWEEN_SCENARIO = "DROP PROCEDURE DUPLICATE_ANALYSIS_FILES_BETWEEN_SCENARIO";

	//////////
	public static final String CALL_PROCEDURE_PRINT_USER_TO_XML = "{CALL PRINT_USER_TO_XML(?, ?)}";
	
	public static final String LOCAL_CREATE_PROCEDURE_PRINT_USER_TO_XML = "CREATE PROCEDURE PRINT_USER_TO_XML(IN DP1 CHAR(36), OUT DP2 VARCHAR(30000) )"
		+ " PARAMETER STYLE JAVA "
		+ " LANGUAGE JAVA "
		+ " READS SQL DATA "
		+ " EXTERNAL NAME 'edu.cs.usask.ca.silver.persistence.datasource.EmbeddedDerbyStorage.getXMLRepresentationForUserProcedure'";

	public static final String REMOTE_CREATE_PROCEDURE_PRINT_USER_TO_XML = "CREATE PROCEDURE PRINT_USER_TO_XML(IN DP1 CHAR(36), OUT DP2 VARCHAR(30000) )"
		+ " PARAMETER STYLE JAVA "
		+ " LANGUAGE JAVA "
		+ " READS SQL DATA "
		+ " EXTERNAL NAME 'procedure.RemoteDerbyStorage.getXMLRepresentationForUserProcedure'";

	
	public static final String DROP_PROCEDURE_PRINT_USER_TO_XML = "DROP PROCEDURE PRINT_USER_TO_XML";


	//////////
	public static final String CALL_PROCEDURE_PRINT_GROUP_TO_XML = "{CALL PRINT_GROUP_TO_XML(?, ?)}";
	
	public static final String LOCAL_CREATE_PROCEDURE_PRINT_GROUP_TO_XML = "CREATE PROCEDURE PRINT_GROUP_TO_XML(IN DP1 CHAR(36), OUT DP2 VARCHAR(30000) )"
		+ " PARAMETER STYLE JAVA "
		+ " LANGUAGE JAVA "
		+ " READS SQL DATA "
		+ " EXTERNAL NAME 'edu.cs.usask.ca.silver.persistence.datasource.EmbeddedDerbyStorage.getXMLRepresentationForGroupProcedure'";

	public static final String REMOTE_CREATE_PROCEDURE_PRINT_GROUP_TO_XML = "CREATE PROCEDURE PRINT_GROUP_TO_XML(IN DP1 CHAR(36), OUT DP2 VARCHAR(30000) )"
		+ " PARAMETER STYLE JAVA "
		+ " LANGUAGE JAVA "
		+ " READS SQL DATA "
		+ " EXTERNAL NAME 'procedure.RemoteDerbyStorage.getXMLRepresentationForGroupProcedure'";

	
	public static final String DROP_PROCEDURE_PRINT_GROUP_TO_XML = "DROP PROCEDURE PRINT_GROUP_TO_XML";

	
	
	//////////
	public static final String CALL_PROCEDURE_PRINT_MODEL_PROJECT_TO_XML = "{CALL PRINT_MODEL_PROJECT_TO_XML(?, ?)}";
	
	public static final String LOCAL_CREATE_PROCEDURE_PRINT_MODEL_PROJECT_TO_XML = "CREATE PROCEDURE PRINT_MODEL_PROJECT_TO_XML(IN DP1 CHAR(36), OUT DP2 VARCHAR(30000) )"
		+ " PARAMETER STYLE JAVA "
		+ " LANGUAGE JAVA "
		+ " READS SQL DATA "
		+ " EXTERNAL NAME 'edu.cs.usask.ca.silver.persistence.datasource.EmbeddedDerbyStorage.getXMLRepresentationForModelProjectProcedure'";

	public static final String REMOTE_CREATE_PROCEDURE_PRINT_MODEL_PROJECT_TO_XML = "CREATE PROCEDURE PRINT_MODEL_PROJECT_TO_XML(IN DP1 CHAR(36), OUT DP2 VARCHAR(30000) )"
		+ " PARAMETER STYLE JAVA "
		+ " LANGUAGE JAVA "
		+ " READS SQL DATA "
		+ " EXTERNAL NAME 'procedure.RemoteDerbyStorage.getXMLRepresentationForModelProjectProcedure'";

	
	public static final String DROP_PROCEDURE_PRINT_MODEL_PROJECT_TO_XML = "DROP PROCEDURE PRINT_MODEL_PROJECT_TO_XML";


	//////////
	public static final String CALL_PROCEDURE_PRINT_MODEL_VERSION_TO_XML = "{CALL PRINT_MODEL_VERSION_TO_XML(?, ?)}";
	
	public static final String LOCAL_CREATE_PROCEDURE_PRINT_MODEL_VERSION_TO_XML = "CREATE PROCEDURE PRINT_MODEL_VERSION_TO_XML(IN DP1 CHAR(36), OUT DP2 VARCHAR(30000) )"
		+ " PARAMETER STYLE JAVA "
		+ " LANGUAGE JAVA "
		+ " READS SQL DATA "
		+ " EXTERNAL NAME 'edu.cs.usask.ca.silver.persistence.datasource.EmbeddedDerbyStorage.getXMLRepresentationForModelVersionProcedure'";

	public static final String REMOTE_CREATE_PROCEDURE_PRINT_MODEL_VERSION_TO_XML = "CREATE PROCEDURE PRINT_MODEL_VERSION_TO_XML(IN DP1 CHAR(36), OUT DP2 VARCHAR(30000) )"
		+ " PARAMETER STYLE JAVA "
		+ " LANGUAGE JAVA "
		+ " READS SQL DATA "
		+ " EXTERNAL NAME 'procedure.RemoteDerbyStorage.getXMLRepresentationForModelVersionProcedure'";

	
	public static final String DROP_PROCEDURE_PRINT_MODEL_VERSION_TO_XML = "DROP PROCEDURE PRINT_MODEL_VERSION_TO_XML";

	//////////
	public static final String CALL_PROCEDURE_PRINT_SCENARIO_COLLECTION_TO_XML = "{CALL PRINT_SCENARIO_COLLECTION_TO_XML(?, ?)}";
	
	public static final String LOCAL_CREATE_PROCEDURE_PRINT_SCENARIO_COLLECTION_TO_XML = "CREATE PROCEDURE PRINT_SCENARIO_COLLECTION_TO_XML(IN DP1 CHAR(36), OUT DP2 VARCHAR(30000) )"
		+ " PARAMETER STYLE JAVA "
		+ " LANGUAGE JAVA "
		+ " READS SQL DATA "
		+ " EXTERNAL NAME 'edu.cs.usask.ca.silver.persistence.datasource.EmbeddedDerbyStorage.getXMLRepresentationForScenarioCollectionProcedure'";

	public static final String REMOTE_CREATE_PROCEDURE_PRINT_SCENARIO_COLLECTION_TO_XML = "CREATE PROCEDURE PRINT_SCENARIO_COLLECTION_TO_XML(IN DP1 CHAR(36), OUT DP2 VARCHAR(30000) )"
		+ " PARAMETER STYLE JAVA "
		+ " LANGUAGE JAVA "
		+ " READS SQL DATA "
		+ " EXTERNAL NAME 'procedure.RemoteDerbyStorage.getXMLRepresentationForScenarioCollectionProcedure'";

	
	public static final String DROP_PROCEDURE_PRINT_SCENARIO_COLLECTION_TO_XML = "DROP PROCEDURE PRINT_SCENARIO_COLLECTION_TO_XML";
	
	
	//////////
	public static final String CALL_PROCEDURE_PRINT_SCENARIO_PS_TO_XML = "{CALL PRINT_SCENARIO_PS_TO_XML(?, ?)}";
	
	public static final String LOCAL_CREATE_PROCEDURE_PRINT_SCENARIO_PS_TO_XML = "CREATE PROCEDURE PRINT_SCENARIO_PS_TO_XML(IN DP1 CHAR(36), OUT DP2 VARCHAR(30000) )"
		+ " PARAMETER STYLE JAVA "
		+ " LANGUAGE JAVA "
		+ " READS SQL DATA "
		+ " EXTERNAL NAME 'edu.cs.usask.ca.silver.persistence.datasource.EmbeddedDerbyStorage.getXMLRepresentationForScenarioProcedure'";

	public static final String REMOTE_CREATE_PROCEDURE_PRINT_SCENARIO_PS_TO_XML = "CREATE PROCEDURE PRINT_SCENARIO_PS_TO_XML(IN DP1 CHAR(36), OUT DP2 VARCHAR(30000) )"
		+ " PARAMETER STYLE JAVA "
		+ " LANGUAGE JAVA "
		+ " READS SQL DATA "
		+ " EXTERNAL NAME 'procedure.RemoteDerbyStorage.getXMLRepresentationForScenarioProcedure'";

	
	public static final String DROP_PROCEDURE_PRINT_SCENARIO_PS_TO_XML = "DROP PROCEDURE PRINT_SCENARIO_PS_TO_XML";
	
	
}
